import cufflinks as cf
import pandas as pd
import numpy as np
import plotly.offline as py
import plotly.graph_objs as go
from IPython.display import display, Markdown, Latex
py.init_notebook_mode(connected=True)
cf.set_config_file(offline=True)
pd.options.display.float_format = '{:20,.2f}'.format
# main data-frame init
dtype = {'County': np.str,
'Employee Name': np.str,
'Job Title': np.str,
'Year': np.int64,
'Notes': np.str,
'Agency': np.str,
'Status': np.str}
def to_float(x):
try:
return float(x)
except Exception as e:
return None
converters = {'Base Pay': to_float,
'Overtime Pay': to_float,
'Other Pay': to_float,
'Benefits': to_float,
'Total Pay': to_float,
'Total Pay & Benefits': to_float}
df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
# definitions
ENTITIES_MAPPING = {
'Teachers': '(?i)teacher',
'Managers': '(?i)principal|director|chief|intendent',
'Superintendents': '(?i)superintendent'
}
ENTITIES = ['Teachers', 'Managers', 'Superintendents']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
HIGHLIGHT_AGECNY = 'San Mateo-Foster City'
def get_df(county, entity, year):
return df[(df['County'] == county) &
(df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) &
(df['Year'] == year)]
def display_mean_salary_by_year(county, entity, year):
ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
ga_mean = ga.mean()
ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
bar = go.Bar(x=ga_mean['Agency'],
y=ga_mean['Total Pay & Benefits'],
marker=dict(color=np.where(ga_mean['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
layout = go.Layout(
margin=go.Margin(
l=60,
r=50,
b=150,
t=100,
pad=2
),
title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
xaxis=dict(
title='Agency',
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
),
yaxis=dict(
title='Mean Salary (USD)',
titlefont=dict(
size=16,
color='rgb(107, 107, 107)'
),
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
)
)
fig = go.Figure(data=[bar], layout=layout)
py.offline.iplot(fig, filename='basic-bar')
"""
ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
"""
# print table under graph
ga_descr = ga.describe()
#ga_descr[ga_descr.columns] = ga_descr[ga_descr.columns].fillna(0).astype(np.int64)
display(ga_descr.sort_values(by='mean', ascending=False))
def display_cumul_salary_change(county, entity, year_from, year_to):
dt = df[(df['County'] == county) &
(df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) &
((df['Year'] == year_from) | (df['Year'] == year_to))]
dt = dt.groupby(['Agency', 'Year'])['Total Pay & Benefits'].mean().to_frame().reset_index()
dt = dt.pivot_table(columns=['Year'], values='Total Pay & Benefits', index=['Agency']).reset_index()
dt.columns = ['Agency', 'year_from', 'year_to'] # because numbers in column names doesn't work
dt['diff'] = dt.apply(lambda row: (row['year_to'] - row['year_from']) * 100 / row['year_from'], axis=1)
dt = dt[(dt['diff'].notnull())]
dt = dt.sort_values(by='diff', ascending=False)
bar = go.Bar(x=dt['Agency'],
y=dt['diff'],
marker=dict(color=np.where(dt['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
layout = go.Layout(
margin=go.Margin(
l=60,
r=50,
b=150,
t=100,
pad=2
),
title='{county}, {entity}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
entity=entity,
year_from=year_from,
year_to=year_to),
xaxis=dict(
title='Agency',
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
),
yaxis=dict(
title='Salary Change (%)',
titlefont=dict(
size=16,
color='rgb(107, 107, 107)'
),
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
)
)
fig = go.Figure(data=[bar], layout=layout)
py.offline.iplot(fig, filename='basic-bar')
# Salary change
year_from = min(YEARS)
year_to = max(YEARS)
for county in COUNTIES:
display(Markdown('# {county}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
year_from=year_from,
year_to=year_to)))
for entity in ENTITIES:
display(Markdown('## {entity}'.format(entity=entity)))
display_cumul_salary_change('San Mateo County', entity, year_from, year_to)
# Mean salary
year_from = min(YEARS)
year_to = max(YEARS)
for county in COUNTIES:
display(Markdown('# {county}, Mean Salary in {year_from} - {year_to}'.format(county=county,
year_from=year_from,
year_to=year_to)))
for year in YEARS:
display(Markdown('## {year}'.format(year=year)))
for entity in ENTITIES:
display(Markdown('### {entity}'.format(entity=entity)))
display_mean_salary_by_year(county, entity, year)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 51.00 | 114,308.22 | 35,249.92 | 24,441.29 | 103,155.85 | 121,072.10 | 141,348.27 | 155,939.98 |
| Las Lomitas Elementary | 86.00 | 112,186.29 | 34,589.27 | 17,674.21 | 101,644.44 | 124,789.11 | 135,003.10 | 162,679.42 |
| Menlo Park City Elementary | 197.00 | 109,100.83 | 31,872.65 | 4,772.96 | 93,540.96 | 120,378.59 | 132,307.00 | 149,728.85 |
| San Mateo Union High | 516.00 | 89,637.90 | 55,348.64 | 0.00 | 43,487.97 | 110,342.98 | 136,326.11 | 177,103.02 |
| Redwood City Elementary | 414.00 | 84,091.86 | 30,399.76 | 3,467.76 | 66,821.58 | 90,014.50 | 108,050.12 | 130,262.17 |
| San Mateo County Office of Education | 98.00 | 81,386.74 | 51,924.93 | 161.00 | 34,584.75 | 87,253.00 | 130,387.50 | 162,407.00 |
| San Mateo-Foster City | 671.00 | 80,915.34 | 34,628.19 | 0.00 | 56,369.85 | 88,089.60 | 109,455.35 | 130,813.29 |
| San Carlos Elementary | 179.00 | 80,820.37 | 30,054.58 | 10,515.54 | 62,665.38 | 93,103.93 | 101,742.90 | 118,654.71 |
| Belmont-Redwood Shores Elementary | 212.00 | 80,434.73 | 30,277.63 | 1.00 | 63,843.00 | 84,095.00 | 104,613.75 | 141,135.00 |
| Pacifica School District | 166.00 | 78,638.99 | 31,585.52 | 0.00 | 56,373.25 | 88,943.20 | 105,053.93 | 126,200.80 |
| South San Francisco Unified | 361.00 | 76,595.15 | 26,264.21 | 0.00 | 65,551.00 | 79,782.00 | 96,918.00 | 127,910.00 |
| Burlingame Elementary | 184.00 | 74,049.30 | 27,328.24 | 4,156.15 | 54,526.63 | 77,799.64 | 96,986.45 | 116,783.89 |
| Bayshore Elementary | 23.00 | 71,390.65 | 24,179.92 | 23,153.00 | 64,017.00 | 76,141.00 | 85,656.50 | 102,482.00 |
| La Honda-Pescadero Unified | 38.00 | 66,915.00 | 30,181.64 | 24.70 | 47,218.51 | 72,050.93 | 87,400.46 | 124,795.88 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 31.00 | 188,238.37 | 57,809.14 | 71,660.30 | 171,328.46 | 187,869.99 | 214,945.49 | 348,435.74 |
| Portola Valley Elementary | 7.00 | 180,136.75 | 65,742.97 | 42,479.98 | 182,593.24 | 187,974.57 | 209,274.52 | 246,767.16 |
| Menlo Park City Elementary | 16.00 | 179,321.71 | 34,523.25 | 140,584.95 | 148,191.75 | 178,038.99 | 198,997.30 | 274,717.64 |
| San Mateo-Foster City | 41.00 | 166,990.78 | 46,817.76 | 43,060.05 | 160,921.63 | 185,196.75 | 192,755.11 | 270,074.32 |
| Burlingame Elementary | 16.00 | 162,261.77 | 40,885.78 | 111,612.22 | 141,249.74 | 153,092.38 | 175,045.06 | 293,857.48 |
| San Mateo County Office of Education | 19.00 | 156,921.00 | 69,794.49 | 307.00 | 137,576.50 | 167,977.00 | 194,805.50 | 272,407.00 |
| Las Lomitas Elementary | 12.00 | 151,795.77 | 51,351.00 | 64,856.23 | 120,715.84 | 162,376.71 | 178,368.52 | 248,142.92 |
| Belmont-Redwood Shores Elementary | 16.00 | 147,806.94 | 38,699.80 | 78,340.00 | 123,041.00 | 149,778.50 | 167,874.00 | 234,988.00 |
| Pacifica School District | 17.00 | 146,165.94 | 53,597.25 | 14,546.44 | 131,817.65 | 150,180.96 | 162,938.29 | 248,636.70 |
| Redwood City Elementary | 42.00 | 145,462.82 | 41,731.43 | 64,276.06 | 131,574.04 | 151,397.20 | 168,140.62 | 268,113.54 |
| San Carlos Elementary | 18.00 | 138,092.58 | 48,904.47 | 11,095.54 | 127,227.71 | 138,932.85 | 156,218.16 | 238,839.36 |
| South San Francisco Unified | 30.00 | 129,668.00 | 46,964.35 | 0.00 | 103,666.25 | 142,952.00 | 158,681.00 | 225,309.00 |
| Bayshore Elementary | 4.00 | 108,459.75 | 63,718.93 | 54,525.00 | 56,265.75 | 97,654.00 | 149,848.00 | 184,006.00 |
| La Honda-Pescadero Unified | 6.00 | 106,035.88 | 31,954.60 | 50,338.65 | 94,916.72 | 117,095.02 | 123,246.04 | 138,866.25 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 2.00 | 319,538.46 | 40,866.92 | 290,641.19 | 305,089.83 | 319,538.46 | 333,987.10 | 348,435.74 |
| San Mateo-Foster City | 1.00 | 270,074.32 | nan | 270,074.32 | 270,074.32 | 270,074.32 | 270,074.32 | 270,074.32 |
| Redwood City Elementary | 1.00 | 268,113.54 | nan | 268,113.54 | 268,113.54 | 268,113.54 | 268,113.54 | 268,113.54 |
| Portola Valley Elementary | 1.00 | 246,767.16 | nan | 246,767.16 | 246,767.16 | 246,767.16 | 246,767.16 | 246,767.16 |
| Menlo Park City Elementary | 2.00 | 243,201.23 | 44,570.94 | 211,684.81 | 227,443.02 | 243,201.23 | 258,959.43 | 274,717.64 |
| San Mateo County Office of Education | 5.00 | 229,732.20 | 26,019.06 | 204,120.00 | 215,341.00 | 225,221.00 | 231,572.00 | 272,407.00 |
| Pacifica School District | 2.00 | 224,064.61 | 34,750.18 | 199,492.52 | 211,778.57 | 224,064.61 | 236,350.66 | 248,636.70 |
| Burlingame Elementary | 3.00 | 221,090.65 | 63,018.18 | 184,528.35 | 184,707.23 | 184,886.11 | 239,371.79 | 293,857.48 |
| San Carlos Elementary | 2.00 | 211,754.71 | 38,303.48 | 184,670.06 | 198,212.38 | 211,754.71 | 225,297.03 | 238,839.36 |
| Bayshore Elementary | 1.00 | 184,006.00 | nan | 184,006.00 | 184,006.00 | 184,006.00 | 184,006.00 | 184,006.00 |
| Belmont-Redwood Shores Elementary | 2.00 | 175,290.50 | 84,425.01 | 115,593.00 | 145,441.75 | 175,290.50 | 205,139.25 | 234,988.00 |
| South San Francisco Unified | 3.00 | 169,704.00 | 66,012.77 | 96,749.00 | 141,901.50 | 187,054.00 | 206,181.50 | 225,309.00 |
| Las Lomitas Elementary | 2.00 | 164,871.74 | 117,763.23 | 81,600.56 | 123,236.15 | 164,871.74 | 206,507.33 | 248,142.92 |
| La Honda-Pescadero Unified | 2.00 | 113,445.35 | 35,950.58 | 88,024.45 | 100,734.90 | 113,445.35 | 126,155.80 | 138,866.25 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 388.00 | 117,053.42 | 38,169.12 | 1,199.06 | 97,240.68 | 129,096.21 | 146,170.96 | 195,573.51 |
| Menlo Park City Elementary | 210.00 | 106,634.16 | 38,686.06 | 1,314.29 | 85,142.04 | 121,874.85 | 136,013.63 | 152,600.47 |
| Woodside Elementary | 39.00 | 105,741.35 | 32,786.61 | 35,032.81 | 85,672.04 | 115,348.25 | 127,850.42 | 165,303.09 |
| Hillsborough City Elementary | 135.00 | 105,162.21 | 36,274.90 | 14,200.68 | 82,639.96 | 117,400.88 | 132,841.88 | 156,858.61 |
| San Carlos Elementary | 180.00 | 83,407.44 | 27,958.95 | 466.41 | 71,778.05 | 93,333.76 | 103,788.60 | 120,869.68 |
| San Mateo-Foster City | 629.00 | 83,212.40 | 29,649.92 | 0.00 | 66,751.62 | 90,426.97 | 106,376.27 | 130,413.40 |
| Cabrillo Unified | 184.00 | 81,777.17 | 34,833.83 | 881.28 | 62,324.38 | 85,248.49 | 110,965.51 | 151,335.71 |
| South San Francisco Unified | 462.00 | 79,156.75 | 26,248.53 | 7,958.79 | 66,955.60 | 84,441.05 | 100,269.82 | 134,160.62 |
| Jefferson Elementary | 352.00 | 78,553.44 | 29,733.54 | 1,159.30 | 62,450.78 | 85,683.54 | 101,899.68 | 130,453.74 |
| Las Lomitas Elementary | 147.00 | 76,413.64 | 60,059.38 | 0.00 | 5,274.05 | 96,178.84 | 131,790.18 | 164,809.81 |
| Pacifica School District | 167.00 | 74,941.96 | 32,807.89 | 279.69 | 44,251.46 | 84,648.41 | 102,492.52 | 124,831.43 |
| Millbrae Elementary | 145.00 | 72,698.63 | 31,377.97 | 1,219.43 | 42,626.00 | 78,673.19 | 100,827.27 | 122,979.02 |
| La Honda-Pescadero Unified | 37.00 | 72,450.63 | 33,348.15 | 66.35 | 60,311.79 | 80,146.95 | 92,991.62 | 129,516.80 |
| Belmont-Redwood Shores Elementary | 293.00 | 62,663.58 | 44,117.38 | 75.50 | 17,713.82 | 70,308.95 | 101,781.41 | 138,947.88 |
| Redwood City Elementary | 683.00 | 58,250.73 | 40,445.78 | 0.00 | 18,701.51 | 59,961.68 | 97,720.35 | 127,244.90 |
| Bayshore Elementary | 26.00 | 57,759.40 | 28,857.41 | 3,612.80 | 34,075.67 | 65,248.93 | 75,227.95 | 103,615.24 |
| Burlingame Elementary | 289.00 | 52,548.26 | 39,689.07 | 0.00 | 10,129.91 | 52,903.21 | 91,831.64 | 115,200.73 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 9.00 | 180,800.32 | 48,691.11 | 89,546.44 | 178,676.13 | 188,815.96 | 201,455.00 | 253,150.62 |
| San Mateo Union High | 35.00 | 179,364.51 | 51,950.72 | 83,158.91 | 157,897.61 | 184,304.04 | 212,086.15 | 330,816.69 |
| Las Lomitas Elementary | 12.00 | 164,175.26 | 52,042.13 | 64,807.13 | 138,380.98 | 179,541.06 | 195,614.17 | 235,632.38 |
| San Mateo-Foster City | 39.00 | 163,547.65 | 40,346.02 | 55,680.49 | 151,279.98 | 182,760.17 | 188,471.58 | 209,969.37 |
| Burlingame Elementary | 15.00 | 163,290.94 | 55,282.29 | 60,098.64 | 153,580.73 | 163,974.68 | 183,922.66 | 300,712.30 |
| Woodside Elementary | 8.00 | 152,223.30 | 62,430.85 | 96,975.96 | 102,800.28 | 148,727.36 | 165,407.88 | 287,480.51 |
| San Carlos Elementary | 16.00 | 151,139.11 | 40,843.87 | 65,947.53 | 135,040.70 | 150,910.72 | 163,008.67 | 246,861.84 |
| Menlo Park City Elementary | 20.00 | 146,769.11 | 72,683.67 | 1,320.89 | 84,959.91 | 166,267.17 | 200,791.70 | 269,385.57 |
| Pacifica School District | 16.00 | 143,586.61 | 51,778.18 | 49,589.52 | 117,958.86 | 148,467.15 | 170,896.62 | 237,194.10 |
| Redwood City Elementary | 39.00 | 140,820.04 | 44,175.73 | 14,975.72 | 131,887.54 | 152,557.36 | 164,632.14 | 223,152.08 |
| Belmont-Redwood Shores Elementary | 17.00 | 140,485.69 | 61,757.17 | 1,480.75 | 138,942.98 | 164,994.56 | 173,561.04 | 233,844.88 |
| South San Francisco Unified | 32.00 | 132,642.32 | 37,510.74 | 37,939.40 | 124,617.19 | 143,527.35 | 151,413.09 | 205,408.48 |
| Jefferson Elementary | 32.00 | 132,317.99 | 47,399.81 | 11,055.74 | 110,352.53 | 150,614.30 | 156,865.38 | 244,588.82 |
| La Honda-Pescadero Unified | 5.00 | 130,490.52 | 10,691.32 | 118,325.88 | 122,842.13 | 129,516.80 | 136,776.02 | 144,991.75 |
| Cabrillo Unified | 20.00 | 126,984.94 | 37,431.22 | 57,603.29 | 96,715.65 | 134,913.92 | 147,660.61 | 200,071.38 |
| Millbrae Elementary | 14.00 | 114,471.56 | 51,463.79 | 48,777.38 | 61,762.23 | 123,167.40 | 152,566.90 | 185,831.11 |
| Bayshore Elementary | 4.00 | 85,788.06 | 34,855.37 | 56,680.98 | 61,627.81 | 76,491.23 | 100,651.48 | 133,488.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Woodside Elementary | 1.00 | 287,480.51 | nan | 287,480.51 | 287,480.51 | 287,480.51 | 287,480.51 | 287,480.51 |
| Hillsborough City Elementary | 1.00 | 253,150.62 | nan | 253,150.62 | 253,150.62 | 253,150.62 | 253,150.62 | 253,150.62 |
| San Mateo Union High | 3.00 | 242,229.10 | 77,920.68 | 184,304.04 | 197,935.30 | 211,566.56 | 271,191.62 | 330,816.69 |
| Menlo Park City Elementary | 2.00 | 241,436.48 | 39,525.98 | 213,487.40 | 227,461.94 | 241,436.48 | 255,411.03 | 269,385.57 |
| Las Lomitas Elementary | 1.00 | 235,632.38 | nan | 235,632.38 | 235,632.38 | 235,632.38 | 235,632.38 | 235,632.38 |
| Burlingame Elementary | 3.00 | 227,565.73 | 63,431.13 | 187,722.55 | 190,992.44 | 194,262.33 | 247,487.32 | 300,712.30 |
| San Carlos Elementary | 2.00 | 217,249.02 | 41,878.86 | 187,636.19 | 202,442.60 | 217,249.02 | 232,055.43 | 246,861.84 |
| Pacifica School District | 2.00 | 211,077.69 | 36,934.18 | 184,961.28 | 198,019.48 | 211,077.69 | 224,135.90 | 237,194.10 |
| Redwood City Elementary | 2.00 | 177,061.68 | 65,181.67 | 130,971.28 | 154,016.48 | 177,061.68 | 200,106.88 | 223,152.08 |
| Jefferson Elementary | 4.00 | 174,835.87 | 58,363.09 | 101,801.80 | 155,829.31 | 176,476.42 | 195,482.97 | 244,588.82 |
| South San Francisco Unified | 4.00 | 169,479.33 | 25,143.86 | 151,963.97 | 152,162.23 | 160,272.43 | 177,589.52 | 205,408.48 |
| Millbrae Elementary | 2.00 | 147,157.88 | 50,309.66 | 111,583.57 | 129,370.72 | 147,157.88 | 164,945.03 | 182,732.18 |
| La Honda-Pescadero Unified | 1.00 | 144,991.75 | nan | 144,991.75 | 144,991.75 | 144,991.75 | 144,991.75 | 144,991.75 |
| San Mateo-Foster City | 1.00 | 122,130.64 | nan | 122,130.64 | 122,130.64 | 122,130.64 | 122,130.64 | 122,130.64 |
| Cabrillo Unified | 5.00 | 120,942.59 | 34,903.87 | 83,882.00 | 108,345.55 | 108,645.35 | 126,715.60 | 177,124.43 |
| Belmont-Redwood Shores Elementary | 3.00 | 116,929.98 | 115,045.04 | 3,850.73 | 58,472.53 | 113,094.34 | 173,469.61 | 233,844.88 |
| Bayshore Elementary | 1.00 | 89,705.70 | nan | 89,705.70 | 89,705.70 | 89,705.70 | 89,705.70 | 89,705.70 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 52.00 | 105,835.64 | 37,843.49 | 19,043.07 | 84,528.15 | 118,646.98 | 136,825.63 | 150,799.05 |
| San Mateo Union High | 416.00 | 103,967.96 | 39,288.93 | 0.00 | 79,755.12 | 116,578.34 | 134,148.12 | 174,815.47 |
| Menlo Park City Elementary | 186.00 | 100,413.68 | 29,965.09 | 11,063.51 | 84,839.62 | 111,633.74 | 122,127.92 | 155,511.51 |
| Hillsborough City Elementary | 121.00 | 100,334.02 | 32,384.40 | 2,340.89 | 84,872.43 | 112,626.72 | 124,116.39 | 143,246.43 |
| San Mateo County Office of Education | 103.00 | 87,739.74 | 39,363.82 | 395.31 | 66,196.79 | 107,152.76 | 119,103.05 | 136,965.99 |
| Jefferson Elementary | 332.00 | 76,217.28 | 25,110.28 | 3,763.12 | 63,432.53 | 82,794.68 | 95,520.44 | 119,883.27 |
| Belmont-Redwood Shores Elementary | 217.00 | 74,392.10 | 30,452.18 | 3,774.79 | 49,936.49 | 80,745.93 | 100,871.89 | 126,241.04 |
| Redwood City Elementary | 495.00 | 74,273.03 | 30,093.96 | 351.67 | 48,675.15 | 77,395.72 | 99,867.10 | 121,788.88 |
| Brisbane Elementary | 37.00 | 73,454.80 | 28,064.80 | 11,053.65 | 50,678.81 | 85,438.75 | 94,788.67 | 118,708.63 |
| Pacifica School District | 165.00 | 73,329.55 | 31,912.64 | 678.11 | 44,900.92 | 83,471.82 | 100,356.14 | 121,840.67 |
| Ravenswood City Elementary | 197.00 | 71,128.68 | 25,138.88 | 0.00 | 56,524.67 | 73,807.54 | 88,427.73 | 115,228.80 |
| Millbrae Elementary | 139.00 | 71,015.98 | 30,785.37 | 17.22 | 46,388.65 | 78,047.89 | 96,976.98 | 119,780.36 |
| Las Lomitas Elementary | 148.00 | 69,855.70 | 53,581.00 | 160.59 | 7,628.11 | 78,512.02 | 120,401.01 | 150,214.89 |
| San Carlos Elementary | 166.00 | 67,331.71 | 20,636.47 | 7,099.70 | 56,748.88 | 72,876.01 | 81,953.33 | 92,283.37 |
| Jefferson Union High | 307.00 | 67,162.87 | 36,646.41 | 787.85 | 36,045.01 | 73,695.53 | 96,644.91 | 139,596.81 |
| San Bruno Park Elementary | 127.00 | 67,075.63 | 22,418.21 | 10,196.68 | 54,798.21 | 72,355.32 | 83,035.36 | 102,585.78 |
| San Mateo-Foster City | 689.00 | 66,616.08 | 39,514.74 | 0.00 | 29,700.67 | 74,407.94 | 98,813.28 | 146,467.25 |
| La Honda-Pescadero Unified | 39.00 | 65,014.45 | 30,052.89 | 12,498.98 | 37,932.88 | 63,799.98 | 91,097.86 | 111,784.48 |
| Burlingame Elementary | 300.00 | 47,605.96 | 39,188.40 | 66.00 | 3,930.75 | 47,564.80 | 84,949.23 | 109,924.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 9.00 | 181,169.81 | 31,783.70 | 111,214.08 | 177,599.65 | 179,517.22 | 192,084.61 | 230,110.31 |
| San Mateo Union High | 34.00 | 179,583.06 | 63,800.06 | 67,855.19 | 146,944.32 | 193,358.54 | 214,268.96 | 349,292.66 |
| San Mateo County Office of Education | 15.00 | 171,824.75 | 42,039.61 | 112,399.23 | 154,657.73 | 160,899.90 | 192,750.15 | 269,154.10 |
| Las Lomitas Elementary | 11.00 | 169,416.52 | 36,724.89 | 87,928.76 | 157,297.48 | 180,683.39 | 184,717.90 | 222,583.06 |
| Portola Valley Elementary | 6.00 | 154,655.21 | 68,101.01 | 43,745.94 | 119,738.83 | 181,106.54 | 197,847.62 | 219,261.33 |
| Burlingame Elementary | 14.00 | 147,353.48 | 46,239.63 | 85,085.58 | 128,919.51 | 150,926.52 | 160,606.88 | 269,387.20 |
| Menlo Park City Elementary | 17.00 | 144,489.42 | 53,016.32 | 21,375.38 | 127,400.90 | 156,662.77 | 175,083.73 | 237,957.52 |
| San Mateo-Foster City | 44.00 | 142,133.09 | 51,832.37 | 3,285.24 | 138,346.99 | 159,025.19 | 164,019.51 | 295,265.20 |
| Pacifica School District | 15.00 | 142,035.24 | 48,802.13 | 54,837.09 | 123,938.61 | 152,575.98 | 162,585.12 | 229,580.87 |
| Belmont-Redwood Shores Elementary | 14.00 | 135,555.77 | 43,988.69 | 62,544.65 | 117,238.43 | 143,240.91 | 152,731.18 | 230,557.28 |
| Redwood City Elementary | 43.00 | 129,560.79 | 48,787.56 | 863.21 | 120,327.95 | 144,624.91 | 157,269.14 | 229,521.57 |
| Ravenswood City Elementary | 22.00 | 124,625.58 | 35,159.64 | 64,941.02 | 115,191.43 | 133,356.90 | 139,483.53 | 219,733.88 |
| Jefferson Elementary | 32.00 | 118,060.53 | 48,631.02 | 10,085.22 | 76,929.27 | 138,715.01 | 143,836.44 | 225,706.35 |
| San Carlos Elementary | 15.00 | 116,900.91 | 22,790.03 | 72,134.56 | 108,930.33 | 117,762.96 | 124,632.11 | 171,667.00 |
| Jefferson Union High | 30.00 | 114,744.61 | 53,042.96 | 489.14 | 73,619.18 | 131,492.35 | 149,925.63 | 225,689.78 |
| La Honda-Pescadero Unified | 5.00 | 109,192.75 | 8,997.91 | 100,878.14 | 101,856.17 | 105,995.60 | 116,063.53 | 121,170.31 |
| San Bruno Park Elementary | 12.00 | 97,827.48 | 27,878.94 | 30,670.58 | 86,900.54 | 103,920.21 | 106,481.04 | 147,856.33 |
| Millbrae Elementary | 15.00 | 96,670.52 | 62,496.14 | 328.69 | 49,454.32 | 94,317.80 | 142,291.30 | 209,097.50 |
| Brisbane Elementary | 6.00 | 86,987.40 | 66,854.66 | 2,191.88 | 50,682.93 | 79,517.39 | 112,352.65 | 196,328.58 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 3.00 | 296,204.93 | 47,582.96 | 257,396.97 | 269,661.06 | 281,925.15 | 315,608.91 | 349,292.66 |
| San Mateo-Foster City | 1.00 | 295,265.20 | nan | 295,265.20 | 295,265.20 | 295,265.20 | 295,265.20 | 295,265.20 |
| Menlo Park City Elementary | 1.00 | 237,957.52 | nan | 237,957.52 | 237,957.52 | 237,957.52 | 237,957.52 | 237,957.52 |
| Hillsborough City Elementary | 1.00 | 230,110.31 | nan | 230,110.31 | 230,110.31 | 230,110.31 | 230,110.31 | 230,110.31 |
| San Mateo County Office of Education | 5.00 | 216,476.90 | 31,660.57 | 192,543.96 | 192,956.34 | 206,971.77 | 220,758.31 | 269,154.10 |
| Millbrae Elementary | 1.00 | 209,097.50 | nan | 209,097.50 | 209,097.50 | 209,097.50 | 209,097.50 | 209,097.50 |
| Pacifica School District | 2.00 | 202,644.54 | 38,093.73 | 175,708.20 | 189,176.37 | 202,644.54 | 216,112.70 | 229,580.87 |
| Redwood City Elementary | 3.00 | 197,373.02 | 30,135.73 | 169,765.51 | 181,298.74 | 192,831.98 | 211,176.78 | 229,521.57 |
| Jefferson Elementary | 3.00 | 190,597.15 | 33,143.64 | 159,851.30 | 173,042.55 | 186,233.80 | 205,970.08 | 225,706.35 |
| Belmont-Redwood Shores Elementary | 3.00 | 175,930.99 | 57,906.98 | 115,223.32 | 148,617.85 | 182,012.37 | 206,284.83 | 230,557.28 |
| Burlingame Elementary | 4.00 | 155,992.73 | 84,868.02 | 88,124.54 | 92,392.36 | 133,229.59 | 196,829.96 | 269,387.20 |
| Las Lomitas Elementary | 2.00 | 155,255.91 | 95,214.97 | 87,928.76 | 121,592.33 | 155,255.91 | 188,919.48 | 222,583.06 |
| San Carlos Elementary | 2.00 | 153,833.50 | 25,220.38 | 136,000.00 | 144,916.75 | 153,833.50 | 162,750.25 | 171,667.00 |
| San Bruno Park Elementary | 1.00 | 147,856.33 | nan | 147,856.33 | 147,856.33 | 147,856.33 | 147,856.33 | 147,856.33 |
| Ravenswood City Elementary | 4.00 | 147,572.45 | 58,114.58 | 77,512.55 | 127,282.01 | 146,521.69 | 166,812.13 | 219,733.88 |
| Brisbane Elementary | 2.00 | 143,652.97 | 74,494.56 | 90,977.36 | 117,315.17 | 143,652.97 | 169,990.77 | 196,328.58 |
| Jefferson Union High | 6.00 | 143,612.26 | 67,642.88 | 30,418.29 | 118,954.05 | 159,840.73 | 175,379.33 | 225,689.78 |
| La Honda-Pescadero Unified | 1.00 | 121,170.31 | nan | 121,170.31 | 121,170.31 | 121,170.31 | 121,170.31 | 121,170.31 |
| Portola Valley Elementary | 1.00 | 43,745.94 | nan | 43,745.94 | 43,745.94 | 43,745.94 | 43,745.94 | 43,745.94 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 438.00 | 106,746.38 | 32,364.59 | 6,441.78 | 91,408.80 | 118,055.93 | 130,396.84 | 168,120.68 |
| Menlo Park City Elementary | 185.00 | 105,104.41 | 30,059.19 | 24,090.59 | 94,554.82 | 115,788.83 | 126,987.88 | 153,199.80 |
| Portola Valley Elementary | 51.00 | 100,642.73 | 32,682.52 | 27,403.30 | 83,698.24 | 111,475.08 | 127,329.18 | 142,243.51 |
| Woodside Elementary | 42.00 | 91,489.52 | 35,015.90 | 27,239.60 | 61,736.57 | 105,456.31 | 119,330.60 | 153,219.27 |
| Sequoia Union High | 561.00 | 90,095.17 | 42,362.88 | 137.12 | 53,709.96 | 103,786.26 | 125,135.60 | 156,745.76 |
| San Mateo County Office of Education | 107.00 | 86,761.85 | 43,038.56 | 172.39 | 46,162.77 | 108,267.94 | 119,327.44 | 136,325.97 |
| Brisbane Elementary | 31.00 | 77,818.67 | 18,070.36 | 18,839.57 | 71,261.17 | 81,433.83 | 87,380.96 | 105,451.17 |
| San Carlos Elementary | 161.00 | 76,820.16 | 25,046.03 | 10,598.42 | 63,564.87 | 82,375.41 | 97,196.71 | 112,622.01 |
| Redwood City Elementary | 449.00 | 75,288.02 | 25,819.08 | 1,834.92 | 60,152.63 | 81,916.51 | 96,344.24 | 116,783.84 |
| Cabrillo Unified | 183.00 | 75,205.05 | 36,026.07 | 110.00 | 49,244.57 | 87,243.61 | 104,155.54 | 142,403.74 |
| Belmont-Redwood Shores Elementary | 205.00 | 73,109.07 | 30,021.01 | 2,665.76 | 59,466.52 | 80,115.69 | 97,904.88 | 123,762.26 |
| Jefferson Elementary | 305.00 | 71,644.48 | 21,574.01 | 4,925.83 | 58,902.86 | 77,942.15 | 88,039.29 | 109,289.78 |
| San Mateo-Foster City | 602.00 | 71,214.45 | 26,121.34 | 583.81 | 57,438.85 | 77,823.61 | 91,047.58 | 112,736.83 |
| Las Lomitas Elementary | 143.00 | 70,782.84 | 54,023.51 | 95.44 | 7,836.59 | 81,882.30 | 122,727.04 | 152,121.77 |
| South San Francisco Unified | 468.00 | 70,256.05 | 24,695.86 | 958.73 | 60,398.03 | 75,477.73 | 89,180.58 | 122,537.33 |
| Pacifica School District | 161.00 | 70,103.76 | 28,779.30 | 4,844.49 | 53,541.39 | 78,631.27 | 93,947.82 | 114,053.43 |
| Millbrae Elementary | 126.00 | 69,823.92 | 27,954.43 | 5,995.26 | 52,522.74 | 79,981.64 | 94,162.41 | 112,745.96 |
| Burlingame Elementary | 174.00 | 68,961.49 | 26,729.16 | 16,394.88 | 46,036.80 | 74,302.80 | 91,756.54 | 112,808.86 |
| Ravenswood City Elementary | 213.00 | 65,991.92 | 26,802.79 | 2,211.88 | 41,526.00 | 71,886.56 | 85,880.97 | 111,852.33 |
| Hillsborough City Elementary | 200.00 | 57,354.30 | 48,936.88 | 67.50 | 2,530.37 | 55,736.11 | 108,284.97 | 140,377.22 |
| Jefferson Union High | 320.00 | 55,105.38 | 37,056.50 | 3.64 | 16,885.65 | 64,265.88 | 86,367.07 | 125,814.87 |
| La Honda-Pescadero Unified | 42.00 | 51,679.88 | 30,051.52 | 1,745.12 | 26,156.20 | 53,969.84 | 74,093.12 | 108,244.30 |
| Bayshore Elementary | 33.00 | 39,379.46 | 31,633.67 | 135.31 | 5,022.80 | 33,913.54 | 63,776.90 | 97,785.69 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 29.00 | 174,610.09 | 37,344.00 | 65,133.59 | 163,524.10 | 178,442.24 | 187,430.04 | 258,306.10 |
| Menlo Park City Elementary | 13.00 | 152,274.04 | 55,485.92 | 18,852.54 | 143,425.06 | 150,900.46 | 185,098.21 | 245,983.71 |
| Las Lomitas Elementary | 10.00 | 151,517.41 | 51,373.59 | 23,094.62 | 151,314.22 | 166,578.73 | 175,308.22 | 213,357.76 |
| Hillsborough City Elementary | 11.00 | 149,780.55 | 45,589.32 | 82,671.33 | 117,504.30 | 164,223.51 | 175,083.02 | 228,250.83 |
| Sequoia Union High | 21.00 | 149,521.13 | 59,225.92 | 5,816.90 | 142,494.62 | 166,466.97 | 183,608.11 | 253,867.20 |
| San Mateo County Office of Education | 16.00 | 147,809.64 | 56,417.21 | 29,261.07 | 107,509.12 | 151,154.52 | 185,551.14 | 240,595.31 |
| San Mateo-Foster City | 36.00 | 145,454.55 | 36,159.08 | 58,301.25 | 138,502.51 | 150,877.10 | 155,011.22 | 282,214.43 |
| Woodside Elementary | 6.00 | 138,135.42 | 67,761.08 | 41,176.92 | 100,659.11 | 145,226.73 | 168,350.56 | 235,320.41 |
| Pacifica School District | 13.00 | 137,986.12 | 40,797.00 | 48,149.41 | 124,462.58 | 136,397.32 | 155,031.49 | 211,025.07 |
| Burlingame Elementary | 12.00 | 130,820.46 | 57,985.23 | 52,437.15 | 78,320.53 | 145,302.76 | 151,915.66 | 250,942.90 |
| South San Francisco Unified | 34.00 | 127,547.12 | 29,951.53 | 54,590.37 | 117,912.68 | 125,232.95 | 140,487.06 | 226,915.94 |
| Jefferson Elementary | 27.00 | 124,934.87 | 27,088.22 | 50,362.61 | 115,391.39 | 124,849.65 | 135,243.35 | 202,870.52 |
| Jefferson Union High | 24.00 | 119,422.92 | 32,177.16 | 34,969.11 | 104,889.84 | 119,926.77 | 134,103.14 | 202,264.92 |
| San Carlos Elementary | 15.00 | 119,201.79 | 45,586.65 | 28,793.78 | 95,778.90 | 132,528.30 | 139,505.67 | 216,285.71 |
| Ravenswood City Elementary | 24.00 | 118,728.53 | 35,708.23 | 43,308.32 | 104,135.26 | 124,797.54 | 141,064.19 | 177,308.07 |
| Belmont-Redwood Shores Elementary | 19.00 | 118,533.85 | 38,676.60 | 66,349.20 | 87,152.72 | 114,703.60 | 144,310.93 | 219,341.77 |
| Redwood City Elementary | 42.00 | 116,009.93 | 38,733.86 | 34,401.89 | 84,208.47 | 124,649.43 | 145,017.41 | 222,483.60 |
| Bayshore Elementary | 2.00 | 114,167.58 | 1,071.69 | 113,409.78 | 113,788.68 | 114,167.58 | 114,546.48 | 114,925.38 |
| Millbrae Elementary | 12.00 | 104,993.60 | 55,724.13 | 30,219.41 | 49,558.56 | 125,105.88 | 129,884.47 | 208,543.22 |
| Brisbane Elementary | 4.00 | 104,810.08 | 74,776.69 | 19,635.50 | 69,039.40 | 99,802.46 | 135,573.14 | 199,999.89 |
| Portola Valley Elementary | 5.00 | 97,005.25 | 56,071.15 | 32,480.14 | 86,928.95 | 89,070.58 | 89,070.58 | 187,476.00 |
| Cabrillo Unified | 23.00 | 92,846.36 | 58,925.94 | 132.00 | 48,843.62 | 99,992.67 | 139,522.17 | 212,956.80 |
| La Honda-Pescadero Unified | 4.00 | 92,784.33 | 13,539.53 | 80,864.83 | 86,600.29 | 89,011.26 | 95,195.30 | 112,249.99 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo-Foster City | 1.00 | 282,214.43 | nan | 282,214.43 | 282,214.43 | 282,214.43 | 282,214.43 | 282,214.43 |
| Sequoia Union High | 1.00 | 253,867.20 | nan | 253,867.20 | 253,867.20 | 253,867.20 | 253,867.20 | 253,867.20 |
| Menlo Park City Elementary | 1.00 | 245,983.71 | nan | 245,983.71 | 245,983.71 | 245,983.71 | 245,983.71 | 245,983.71 |
| San Mateo Union High | 3.00 | 238,390.98 | 33,790.30 | 199,376.14 | 228,433.42 | 257,490.69 | 257,898.40 | 258,306.10 |
| Woodside Elementary | 1.00 | 235,320.41 | nan | 235,320.41 | 235,320.41 | 235,320.41 | 235,320.41 | 235,320.41 |
| Hillsborough City Elementary | 1.00 | 228,250.83 | nan | 228,250.83 | 228,250.83 | 228,250.83 | 228,250.83 | 228,250.83 |
| San Carlos Elementary | 1.00 | 216,285.71 | nan | 216,285.71 | 216,285.71 | 216,285.71 | 216,285.71 | 216,285.71 |
| San Mateo County Office of Education | 5.00 | 205,128.46 | 22,470.00 | 184,321.69 | 189,239.48 | 199,595.98 | 211,889.86 | 240,595.31 |
| Redwood City Elementary | 2.00 | 200,482.88 | 31,113.72 | 178,482.16 | 189,482.52 | 200,482.88 | 211,483.24 | 222,483.60 |
| Jefferson Elementary | 2.00 | 183,623.54 | 27,219.33 | 164,376.57 | 174,000.06 | 183,623.54 | 193,247.03 | 202,870.52 |
| Pacifica School District | 2.00 | 183,028.28 | 39,593.44 | 155,031.49 | 169,029.89 | 183,028.28 | 197,026.67 | 211,025.07 |
| South San Francisco Unified | 4.00 | 182,013.99 | 30,112.35 | 163,849.77 | 165,280.11 | 168,645.12 | 185,379.01 | 226,915.94 |
| Burlingame Elementary | 3.00 | 172,084.90 | 84,974.36 | 82,092.05 | 132,655.90 | 183,219.75 | 217,081.33 | 250,942.90 |
| Jefferson Union High | 5.00 | 143,455.95 | 50,730.40 | 64,076.40 | 141,702.48 | 142,734.55 | 166,501.38 | 202,264.92 |
| Brisbane Elementary | 2.00 | 142,753.63 | 80,958.44 | 85,507.37 | 114,130.50 | 142,753.63 | 171,376.76 | 199,999.89 |
| Belmont-Redwood Shores Elementary | 4.00 | 140,034.66 | 53,341.11 | 108,009.34 | 108,920.61 | 116,393.77 | 147,507.83 | 219,341.77 |
| Ravenswood City Elementary | 6.00 | 128,929.19 | 38,630.81 | 67,620.40 | 111,012.66 | 134,809.36 | 150,662.99 | 177,308.07 |
| Cabrillo Unified | 5.00 | 119,802.87 | 79,135.06 | 140.00 | 93,829.21 | 145,439.40 | 146,648.94 | 212,956.80 |
| Las Lomitas Elementary | 2.00 | 118,226.19 | 134,536.36 | 23,094.62 | 70,660.40 | 118,226.19 | 165,791.98 | 213,357.76 |
| La Honda-Pescadero Unified | 1.00 | 112,249.99 | nan | 112,249.99 | 112,249.99 | 112,249.99 | 112,249.99 | 112,249.99 |
| Millbrae Elementary | 3.00 | 111,146.49 | 85,136.62 | 50,887.38 | 62,448.12 | 74,008.86 | 141,276.04 | 208,543.22 |
| Portola Valley Elementary | 1.00 | 86,928.95 | nan | 86,928.95 | 86,928.95 | 86,928.95 | 86,928.95 | 86,928.95 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Redwood City Elementary | 1.00 | 106,291.19 | nan | 106,291.19 | 106,291.19 | 106,291.19 | 106,291.19 | 106,291.19 |
| Portola Valley Elementary | 51.00 | 103,730.36 | 36,416.99 | 12,196.40 | 82,261.15 | 116,476.30 | 131,327.46 | 147,461.64 |
| San Mateo Union High | 448.00 | 102,353.30 | 32,984.91 | 219.40 | 85,361.62 | 114,449.71 | 126,636.85 | 161,873.28 |
| Menlo Park City Elementary | 175.00 | 98,317.48 | 27,246.94 | 16,259.12 | 86,321.99 | 107,683.84 | 118,193.43 | 138,092.83 |
| Sequoia Union High | 463.00 | 97,190.92 | 31,663.12 | 2,369.70 | 76,728.01 | 106,057.00 | 121,067.18 | 152,706.34 |
| San Mateo County Office of Education | 107.00 | 82,472.19 | 39,042.44 | 1,442.17 | 61,257.54 | 101,141.14 | 112,090.66 | 125,511.89 |
| Belmont-Redwood Shores Elementary | 192.00 | 75,600.08 | 29,794.20 | 389.37 | 61,106.56 | 82,535.86 | 100,154.55 | 120,567.44 |
| Millbrae Elementary | 118.00 | 73,237.94 | 25,669.15 | 1,129.65 | 59,877.69 | 82,400.92 | 93,143.48 | 110,617.36 |
| South San Francisco Unified | 475.00 | 71,240.39 | 23,378.12 | 3,571.38 | 61,071.07 | 75,791.69 | 89,006.58 | 123,700.60 |
| Jefferson Elementary | 294.00 | 70,895.21 | 20,457.99 | 8.75 | 59,641.22 | 76,396.02 | 86,299.99 | 104,356.13 |
| Pacifica School District | 1.00 | 68,010.68 | nan | 68,010.68 | 68,010.68 | 68,010.68 | 68,010.68 | 68,010.68 |
| Burlingame Elementary | 168.00 | 67,966.89 | 23,658.30 | 124.49 | 52,334.50 | 72,235.18 | 88,342.05 | 105,432.58 |
| Las Lomitas Elementary | 140.00 | 66,225.80 | 52,224.62 | 121.74 | 4,074.07 | 76,045.21 | 117,819.40 | 143,552.72 |
| San Mateo-Foster City | 582.00 | 65,746.56 | 24,875.46 | 5,265.89 | 47,096.58 | 72,331.05 | 86,252.96 | 104,866.65 |
| Jefferson Union High | 254.00 | 64,031.08 | 23,561.85 | 22.25 | 50,859.10 | 67,971.27 | 81,681.20 | 121,476.34 |
| Ravenswood City Elementary | 212.00 | 58,770.82 | 25,177.61 | 154.22 | 36,492.71 | 65,393.61 | 77,108.40 | 100,902.64 |
| Hillsborough City Elementary | 197.00 | 57,593.77 | 48,096.59 | 60.00 | 2,617.60 | 65,825.39 | 106,352.10 | 136,499.81 |
| Woodside Elementary | 69.00 | 56,385.01 | 49,752.68 | 159.06 | 2,505.80 | 57,991.67 | 104,225.30 | 145,463.08 |
| San Carlos Elementary | 229.00 | 56,255.93 | 39,349.96 | 43.71 | 9,461.09 | 68,216.61 | 91,471.21 | 114,395.08 |
| La Honda-Pescadero Unified | 37.00 | 53,344.68 | 27,025.29 | 2,578.48 | 31,291.49 | 61,565.28 | 70,151.45 | 97,885.36 |
| Bayshore Elementary | 30.00 | 39,795.12 | 31,961.47 | 125.00 | 2,765.62 | 49,401.62 | 65,832.02 | 95,778.24 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 3.00 | 196,362.47 | 18,333.60 | 182,528.68 | 185,965.17 | 189,401.66 | 203,279.36 | 217,157.07 |
| Woodside Elementary | 3.00 | 175,041.88 | 45,183.77 | 138,713.16 | 149,744.42 | 160,775.68 | 193,206.23 | 225,636.79 |
| San Mateo Union High | 30.00 | 173,871.02 | 39,811.63 | 42,959.22 | 159,690.79 | 178,330.42 | 187,605.56 | 256,250.04 |
| Sequoia Union High | 13.00 | 166,950.48 | 36,371.65 | 89,080.97 | 146,889.63 | 173,254.39 | 182,101.45 | 247,151.76 |
| San Mateo County Office of Education | 13.00 | 155,722.93 | 37,554.85 | 80,678.60 | 140,504.79 | 160,898.33 | 175,217.87 | 225,169.08 |
| Menlo Park City Elementary | 12.00 | 153,029.81 | 44,490.77 | 77,499.89 | 128,323.10 | 160,746.95 | 179,149.77 | 239,775.73 |
| Burlingame Elementary | 11.00 | 137,997.87 | 49,220.68 | 53,570.02 | 138,168.42 | 139,949.19 | 152,714.24 | 235,077.69 |
| Hillsborough City Elementary | 12.00 | 134,573.83 | 47,211.22 | 60,812.68 | 92,941.60 | 151,601.88 | 161,392.72 | 221,387.78 |
| Millbrae Elementary | 9.00 | 133,744.92 | 38,292.60 | 57,249.90 | 125,513.55 | 132,357.43 | 148,152.90 | 200,738.98 |
| Belmont-Redwood Shores Elementary | 16.00 | 131,621.45 | 42,031.48 | 57,996.80 | 102,749.76 | 143,481.64 | 158,409.88 | 204,954.78 |
| Jefferson Elementary | 23.00 | 120,422.29 | 27,386.57 | 37,805.39 | 111,583.60 | 119,928.13 | 128,084.18 | 193,615.91 |
| Ravenswood City Elementary | 20.00 | 113,298.29 | 33,958.73 | 23,336.36 | 101,309.19 | 117,317.07 | 124,494.35 | 195,853.86 |
| South San Francisco Unified | 35.00 | 112,020.05 | 34,741.47 | 44,560.16 | 98,284.98 | 117,120.98 | 130,195.55 | 208,827.57 |
| Las Lomitas Elementary | 13.00 | 110,235.79 | 48,377.67 | 16,877.43 | 78,674.18 | 106,692.60 | 156,093.40 | 171,198.28 |
| San Mateo-Foster City | 36.00 | 110,072.34 | 35,378.78 | 34,513.53 | 105,150.94 | 119,372.88 | 122,299.48 | 234,083.11 |
| San Carlos Elementary | 15.00 | 109,776.44 | 52,289.83 | 3,403.92 | 102,270.49 | 121,359.87 | 133,254.85 | 213,404.86 |
| Bayshore Elementary | 2.00 | 108,843.26 | 1,063.59 | 108,091.19 | 108,467.23 | 108,843.26 | 109,219.30 | 109,595.34 |
| Jefferson Union High | 31.00 | 90,777.02 | 37,540.64 | 11,790.66 | 58,088.41 | 94,270.92 | 116,867.35 | 188,310.28 |
| La Honda-Pescadero Unified | 7.00 | 77,049.86 | 33,199.20 | 11,674.89 | 69,059.82 | 85,020.75 | 98,251.76 | 108,030.18 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Sequoia Union High | 1.00 | 247,151.76 | nan | 247,151.76 | 247,151.76 | 247,151.76 | 247,151.76 | 247,151.76 |
| San Mateo-Foster City | 1.00 | 234,083.11 | nan | 234,083.11 | 234,083.11 | 234,083.11 | 234,083.11 | 234,083.11 |
| San Mateo Union High | 4.00 | 230,625.29 | 29,103.18 | 193,249.36 | 214,840.83 | 236,500.89 | 252,285.35 | 256,250.04 |
| Woodside Elementary | 1.00 | 225,636.79 | nan | 225,636.79 | 225,636.79 | 225,636.79 | 225,636.79 | 225,636.79 |
| Hillsborough City Elementary | 1.00 | 221,387.78 | nan | 221,387.78 | 221,387.78 | 221,387.78 | 221,387.78 | 221,387.78 |
| Portola Valley Elementary | 1.00 | 217,157.07 | nan | 217,157.07 | 217,157.07 | 217,157.07 | 217,157.07 | 217,157.07 |
| San Carlos Elementary | 1.00 | 213,404.86 | nan | 213,404.86 | 213,404.86 | 213,404.86 | 213,404.86 | 213,404.86 |
| Menlo Park City Elementary | 2.00 | 209,161.91 | 43,294.48 | 178,548.09 | 193,855.00 | 209,161.91 | 224,468.82 | 239,775.73 |
| Millbrae Elementary | 1.00 | 200,738.98 | nan | 200,738.98 | 200,738.98 | 200,738.98 | 200,738.98 | 200,738.98 |
| San Mateo County Office of Education | 5.00 | 188,638.23 | 24,029.25 | 161,722.01 | 175,217.87 | 184,915.87 | 196,166.34 | 225,169.08 |
| Burlingame Elementary | 3.00 | 188,365.39 | 40,581.49 | 161,795.59 | 165,009.23 | 168,222.88 | 201,650.29 | 235,077.69 |
| Jefferson Elementary | 2.00 | 173,525.42 | 28,412.24 | 153,434.93 | 163,480.17 | 173,525.42 | 183,570.66 | 193,615.91 |
| South San Francisco Unified | 4.00 | 156,671.99 | 39,689.03 | 112,415.30 | 140,551.02 | 152,722.54 | 168,843.52 | 208,827.57 |
| Ravenswood City Elementary | 3.00 | 155,942.76 | 34,667.09 | 133,316.02 | 135,987.21 | 138,658.40 | 167,256.13 | 195,853.86 |
| Belmont-Redwood Shores Elementary | 4.00 | 150,244.52 | 47,646.82 | 109,660.76 | 110,668.93 | 143,181.27 | 182,756.86 | 204,954.78 |
| Jefferson Union High | 6.00 | 116,717.11 | 59,560.41 | 11,790.66 | 104,079.25 | 128,001.29 | 143,070.73 | 188,310.28 |
| La Honda-Pescadero Unified | 1.00 | 108,030.18 | nan | 108,030.18 | 108,030.18 | 108,030.18 | 108,030.18 | 108,030.18 |
| Las Lomitas Elementary | 3.00 | 104,582.00 | 24,919.65 | 78,674.18 | 92,683.39 | 106,692.60 | 117,535.91 | 128,379.22 |
All stats are based on: https://transparentcalifornia.com/agencies/salaries/school-districts/